What is a transaction and what are ACID properties?
1252
24-Sep-2019
Updated on 16-Sep-2020
Anonymous User
24-Sep-2019Where a transaction is a logical unit of work in which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, and Durability. These are the properties of a transaction.
Atomicity: In this property, the server ensures the completeness of all transactions performed. After checks, every transaction is completed successfully if not then transaction is aborted at the failure point and the previous transaction is rolled back to its initial state as changes are undone .
Consistency: In this property, the server ensures that all changes made through successful transaction are reflected properly on the database.
Isolation: In this property, The server ensures that all transactions are performed independently and changes made by one transaction are not reflected on other .
Durability: In this property, The server ensures that the changes made in the database with committed transactions persist as it is even after a system failure.